Tabela UserDat

Definicja tabeli UserDat

Name

UserDat

Code

UserDat

Comment

 


Lista kolumn tabeli UserDat

Name

Code

password

password

user_login

user_login

CategoryName

CategoryName

fname

fname

lname

lname

email

email

user_ID

user_ID

groups

groups

user_cat

user_cat

language

language

profile

profile

ext_ID

ext_ID

HospID

HospID

who_modified

who_modified

db_ID

db_ID

LastSuccessLoginDT

LastSuccessLoginDT

LastFailedLoginDT

LastFailedLoginDT

PasswordExpireDT

PasswordExpireDT

LastModifiedDT

LastModifiedDT


Kolumna password tabeli UserDat

Definicja kolumny password tabeli UserDat

Name

password

Code

password

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna user_login tabeli UserDat

Definicja kolumny user_login tabeli UserDat

Name

user_login

Code

user_login

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna CategoryName tabeli UserDat

Definicja kolumny CategoryName tabeli UserDat

Name

CategoryName

Code

CategoryName

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna fname tabeli UserDat

Definicja kolumny fname tabeli UserDat

Name

fname

Code

fname

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna lname tabeli UserDat

Definicja kolumny lname tabeli UserDat

Name

lname

Code

lname

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna email tabeli UserDat

Definicja kolumny email tabeli UserDat

Name

email

Code

email

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna user_ID tabeli UserDat

Definicja kolumny user_ID tabeli UserDat

Name

user_ID

Code

user_ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna groups tabeli UserDat

Definicja kolumny groups tabeli UserDat

Name

groups

Code

groups

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna user_cat tabeli UserDat

Definicja kolumny user_cat tabeli UserDat

Name

user_cat

Code

user_cat

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna language tabeli UserDat

Definicja kolumny language tabeli UserDat

Name

language

Code

language

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna profile tabeli UserDat

Definicja kolumny profile tabeli UserDat

Name

profile

Code

profile

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna ext_ID tabeli UserDat

Definicja kolumny ext_ID tabeli UserDat

Name

ext_ID

Code

ext_ID

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna HospID tabeli UserDat

Definicja kolumny HospID tabeli UserDat

Name

HospID

Code

HospID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna who_modified tabeli UserDat

Definicja kolumny who_modified tabeli UserDat

Name

who_modified

Code

who_modified

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna db_ID tabeli UserDat

Definicja kolumny db_ID tabeli UserDat

Name

db_ID

Code

db_ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LastSuccessLoginDT tabeli UserDat

Definicja kolumny LastSuccessLoginDT tabeli UserDat

Name

LastSuccessLoginDT

Code

LastSuccessLoginDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LastFailedLoginDT tabeli UserDat

Definicja kolumny LastFailedLoginDT tabeli UserDat

Name

LastFailedLoginDT

Code

LastFailedLoginDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PasswordExpireDT tabeli UserDat

Definicja kolumny PasswordExpireDT tabeli UserDat

Name

PasswordExpireDT

Code

PasswordExpireDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli UserDat

Definicja kolumny LastModifiedDT tabeli UserDat

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment